home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Amiga Plus 2002 #11
/
Amiga Plus CD - 2002 - No. 11.iso
/
amigaoscd
/
amigapluscd
/
AP-Website
/
news
/
admin
/
index.php
< prev
next >
Wrap
Text File
|
2002-01-27
|
7KB
|
219 lines
<html>
<head>
<title>AmigaPlus News Admin</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#66CCFF" text="#000000">
<?php
$server = "db04.puretec.de";
$db = "db24905524";
$login = "p343302";
$pass = "90f42902";
$dbwww = mysql_connect($server,$login,$pass);
mysql_select_db($db,$dbwww);
?>
<p><b><font size="+1">AmigaPlus News Admin</font></b></p>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td bgcolor="#0099FF"><b>News hinzufügen</b></td>
</tr>
<tr>
<td>
<form name="add_news" method="post" action="add_news.php">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="150" valign="top">
<div align="left">Überschrift</div>
</td>
<td>
<input type="text" name="title" size="50" maxlength="200">
</td>
</tr>
<tr>
<td width="150" valign="top">
<div align="left">
<p>Newstext</p>
<p><font size="-1">Zeilenumbrüche nur machen wenn auch wirklich
ein Absatz erscheinen soll in den News.</font></p>
</div>
</td>
<td>
<textarea name="newstext" cols="70" rows="10" wrap="VIRTUAL"></textarea>
</td>
</tr>
<tr>
<td width="150" valign="top">
<div align="left">Link</div>
</td>
<td>
<input type="text" name="link" size="50" maxlength="200">
</td>
</tr>
<tr>
<td width="150" valign="top">
<div align="left">Quelle</div>
</td>
<td>
<input type="text" name="source" size="50" maxlength="100">
</td>
</tr>
<tr>
<td width="150" valign="top">
<div align="left">Autor</div>
</td>
<td>
<select name="author">
<?php
$query = "select * from amigaplusnews_authors order by short_name asc";
$query_result = mysql_query($query,$dbwww);
while($row = mysql_fetch_array($query_result))
{
?>
<option value="<?php echo $row["id"] ?>"><?php echo $row["short_name"]." - ".$row["full_name"]; ?></option>
<?php
}
?>
</select>
</td>
</tr>
<tr>
<td width="150" valign="top">
<div align="left">Kategorie</div>
</td>
<td>
<select name="category">
<?php
$query = "select * from amigaplusnews_categories order by name asc";
$query_result = mysql_query($query,$dbwww);
while($row = mysql_fetch_array($query_result))
{
?>
<option value="<?php echo $row["id"] ?>"><?php echo $row["name"] ?></option>
<?php
}
?>
</select>
</td>
</tr>
<tr>
<td width="150" valign="top">
<div align="left">Zielframe/fenster</div>
</td>
<td>
<input type="text" name="target" value="_blank" maxlength="100">
</td>
</tr>
</table>
<input type="submit" name="submit" value="speichern">
</form>
</td>
</tr>
</table>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td bgcolor="#0099FF"><b>News ändern</b></td>
</tr>
<tr>
<td>
<form name="change_news" method="post" action="change_news.php">
<select name="newsentry">
<?php
$query = "select * from amigaplusnews_content where visible = 1 order by timestamp desc";
$query_result = mysql_query($query,$dbwww);
while($row = mysql_fetch_array($query_result))
{
?>
<option value="<?php echo $row["id"] ?>"><?php echo $row["title"] ?></option>
<?php
}
?>
</select>
<br>
<input type="submit" name="submit" value="ändern">
</form>
</td>
</tr>
</table>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td bgcolor="#0099FF"><b>News löschen</b></td>
</tr>
<tr>
<td>
<form name="delete_news" method="post" action="delete_news.php">
<select name="newsentry">
<?php
$query = "select * from amigaplusnews_content where visible = 1 order by timestamp desc";
$query_result = mysql_query($query,$dbwww);
while($row = mysql_fetch_array($query_result))
{
?>
<option value="<?php echo $row["id"] ?>"><?php echo $row["title"] ?></option>
<?php
}
?>
</select>
<br>
<input type="submit" name="submit" value="löschen">
</form>
</td>
</tr>
</table>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td bgcolor="#0099FF"><b>Autor hinzufügen </b><font size="-1">(ohne die
eckigen Klammern)</font></td>
</tr>
<tr>
<td>
<form name="add_author" method="post" action="add_author.php">
<p>Kurzform: [
<input type="text" name="short_name" maxlength="10">
]<br>
Voller Name:
<input type="text" name="full_name" maxlength="100" size="30">
<br>
<input type="submit" name="submit" value="speichern">
</p>
</form>
</td>
</tr>
</table>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td bgcolor="#0099FF"><b>Autor ändern</b></td>
</tr>
<tr>
<td>
<form name="change_author" method="post" action="change_author.php">
<select name="authorentry">
<?php
$query = "select * from amigaplusnews_authors order by short_name asc";
$query_result = mysql_query($query,$dbwww);
while($row = mysql_fetch_array($query_result))
{
?>
<option value="<?php echo $row["id"] ?>"><?php echo $row["short_name"]." - ".$row["full_name"]; ?></option>
<?php
}
?>
</select>
<br>
<input type="submit" name="submit" value="ändern">
</form>
</td>
</tr>
</table>
<p> </p>
</body>
</html>